| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | |
|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 01-12-2010 08:26 | 2.55 | 17850.0 | United Kingdom |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 01-12-2010 08:26 | 2.75 | 17850.0 | United Kingdom |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 01-12-2010 08:26 | 3.39 | 17850.0 | United Kingdom |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 994 | 536520 | 22092 | BLUE PAISLEY TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 995 | 536520 | 22469 | HEART OF WICKER SMALL | 1 | 01-12-2010 12:43 | 1.65 | 14729.0 | United Kingdom |
| 996 | 536520 | 22100 | SKULLS SQUARE TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 997 | 536520 | 22096 | PINK PAISLEY SQUARE TISSUE BOX | 1 | 01-12-2010 12:43 | 1.25 | 14729.0 | United Kingdom |
| 998 | 536520 | 22583 | PACK OF 6 HANDBAG GIFT BOXES | 1 | 01-12-2010 12:43 | 2.55 | 14729.0 | United Kingdom |
999 rows × 8 columns
'01-12-2010 12:43'
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Quantity | 999.0 | 12.795796 | 38.441434 | -24.0 | 2.00 | 4.0 | 12.00 | 600.0 |
| UnitPrice | 999.0 | 3.038899 | 5.899624 | 0.0 | 1.25 | 2.1 | 3.75 | 165.0 |
| CustomerID | 998.0 | 16024.426854 | 1865.614470 | 12431.0 | 14688.00 | 16210.0 | 17908.00 | 18085.0 |
InvoiceNo object StockCode object Description object Quantity int64 InvoiceDate object UnitPrice float64 CustomerID float64 Country object dtype: object
InvoiceNo object StockCode object Description object Quantity int64 InvoiceDate datetime64[ns] UnitPrice float64 CustomerID float64 Country object dtype: object
2010-01-13 00:00:00
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | TotalSum | Frequency | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-01-12 08:26:00 | 2.55 | 17850.0 | United Kingdom | 15.30 | 0 days 15:34:00 |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 0 days 15:34:00 |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 2010-01-12 08:26:00 | 2.75 | 17850.0 | United Kingdom | 22.00 | 0 days 15:34:00 |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 0 days 15:34:00 |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 2010-01-12 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 0 days 15:34:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 994 | 536520 | 22092 | BLUE PAISLEY TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 0 days 11:17:00 |
| 995 | 536520 | 22469 | HEART OF WICKER SMALL | 1 | 2010-01-12 12:43:00 | 1.65 | 14729.0 | United Kingdom | 1.65 | 0 days 11:17:00 |
| 996 | 536520 | 22100 | SKULLS SQUARE TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 0 days 11:17:00 |
| 997 | 536520 | 22096 | PINK PAISLEY SQUARE TISSUE BOX | 1 | 2010-01-12 12:43:00 | 1.25 | 14729.0 | United Kingdom | 1.25 | 0 days 11:17:00 |
| 998 | 536520 | 22583 | PACK OF 6 HANDBAG GIFT BOXES | 1 | 2010-01-12 12:43:00 | 2.55 | 14729.0 | United Kingdom | 2.55 | 0 days 11:17:00 |
999 rows × 10 columns
| InvoiceDate | InvoiceNo | TotalSum | |
|---|---|---|---|
| CustomerID | |||
| 12431.0 | 13.950000 | 14 | 358.25 |
| 12583.0 | 15.250000 | 20 | 855.86 |
| 12791.0 | 12.550000 | 2 | 192.60 |
| 12838.0 | 12.050000 | 59 | 390.79 |
| 13047.0 | 15.416667 | 17 | 366.63 |
| 13255.0 | 12.033333 | 6 | 225.70 |
| 13408.0 | 13.350000 | 11 | 1024.68 |
| 13448.0 | 13.116667 | 18 | 443.96 |
| 13694.0 | 11.800000 | 6 | 842.12 |
| 13705.0 | 13.516667 | 10 | 318.14 |
| 13747.0 | 13.383333 | 1 | 79.60 |
| 13748.0 | 15.000000 | 1 | 204.00 |
| 13758.0 | 11.866667 | 17 | 362.45 |
| 13767.0 | 13.216667 | 14 | 507.88 |
| 14045.0 | 12.466667 | 1 | 326.40 |
| 14307.0 | 12.316667 | 48 | 783.11 |
| 14527.0 | 14.316667 | 1 | -27.50 |
| 14688.0 | 14.383333 | 19 | 444.98 |
| 14729.0 | 11.283333 | 54 | 265.87 |
| 14849.0 | 11.616667 | 17 | 355.84 |
| 15100.0 | 14.850000 | 1 | 350.40 |
| 15291.0 | 14.466667 | 2 | 328.80 |
| 15311.0 | 14.183333 | 36 | 445.33 |
| 15513.0 | 12.633333 | 3 | 357.00 |
| 15862.0 | 12.650000 | 64 | 354.23 |
| 15983.0 | 11.750000 | 32 | 440.89 |
| 16029.0 | 14.033333 | 8 | 3702.12 |
| 16098.0 | 14.250000 | 12 | 430.60 |
| 16210.0 | 11.550000 | 14 | 2474.74 |
| 16218.0 | 12.516667 | 28 | 471.30 |
| 16250.0 | 14.016667 | 14 | 226.14 |
| 16552.0 | 11.400000 | 5 | 95.29 |
| 16583.0 | 11.950000 | 14 | 233.45 |
| 17181.0 | 11.366667 | 2 | 155.52 |
| 17377.0 | 11.416667 | 15 | 223.90 |
| 17420.0 | 14.066667 | 7 | 130.85 |
| 17511.0 | 13.683333 | 24 | 1825.74 |
| 17548.0 | 13.600000 | 7 | -141.48 |
| 17809.0 | 14.316667 | 1 | 34.80 |
| 17850.0 | 12.433333 | 84 | 1499.34 |
| 17897.0 | 11.366667 | 36 | 140.39 |
| 17908.0 | 12.250000 | 58 | 243.28 |
| 17920.0 | 12.183333 | 81 | 514.41 |
| 17924.0 | 13.150000 | 2 | 279.00 |
| 17951.0 | 11.333333 | 5 | 295.50 |
| 17968.0 | 11.616667 | 85 | 277.35 |
| 18074.0 | 14.116667 | 13 | 489.60 |
| 18085.0 | 11.866667 | 9 | 303.90 |
| Recency | Frequency | Monetary | |
|---|---|---|---|
| CustomerID | |||
| 12431.0 | 13.950000 | 14 | 358.25 |
| 12583.0 | 15.250000 | 20 | 855.86 |
| 12791.0 | 12.550000 | 2 | 192.60 |
| 12838.0 | 12.050000 | 59 | 390.79 |
| 13047.0 | 15.416667 | 17 | 366.63 |
| 13255.0 | 12.033333 | 6 | 225.70 |
| 13408.0 | 13.350000 | 11 | 1024.68 |
| 13448.0 | 13.116667 | 18 | 443.96 |
| 13694.0 | 11.800000 | 6 | 842.12 |
| 13705.0 | 13.516667 | 10 | 318.14 |
| 13747.0 | 13.383333 | 1 | 79.60 |
| 13748.0 | 15.000000 | 1 | 204.00 |
| 13758.0 | 11.866667 | 17 | 362.45 |
| 13767.0 | 13.216667 | 14 | 507.88 |
| 14045.0 | 12.466667 | 1 | 326.40 |
| 14307.0 | 12.316667 | 48 | 783.11 |
| 14527.0 | 14.316667 | 1 | -27.50 |
| 14688.0 | 14.383333 | 19 | 444.98 |
| 14729.0 | 11.283333 | 54 | 265.87 |
| 14849.0 | 11.616667 | 17 | 355.84 |
| 15100.0 | 14.850000 | 1 | 350.40 |
| 15291.0 | 14.466667 | 2 | 328.80 |
| 15311.0 | 14.183333 | 36 | 445.33 |
| 15513.0 | 12.633333 | 3 | 357.00 |
| 15862.0 | 12.650000 | 64 | 354.23 |
| 15983.0 | 11.750000 | 32 | 440.89 |
| 16029.0 | 14.033333 | 8 | 3702.12 |
| 16098.0 | 14.250000 | 12 | 430.60 |
| 16210.0 | 11.550000 | 14 | 2474.74 |
| 16218.0 | 12.516667 | 28 | 471.30 |
| 16250.0 | 14.016667 | 14 | 226.14 |
| 16552.0 | 11.400000 | 5 | 95.29 |
| 16583.0 | 11.950000 | 14 | 233.45 |
| 17181.0 | 11.366667 | 2 | 155.52 |
| 17377.0 | 11.416667 | 15 | 223.90 |
| 17420.0 | 14.066667 | 7 | 130.85 |
| 17511.0 | 13.683333 | 24 | 1825.74 |
| 17548.0 | 13.600000 | 7 | -141.48 |
| 17809.0 | 14.316667 | 1 | 34.80 |
| 17850.0 | 12.433333 | 84 | 1499.34 |
| 17897.0 | 11.366667 | 36 | 140.39 |
| 17908.0 | 12.250000 | 58 | 243.28 |
| 17920.0 | 12.183333 | 81 | 514.41 |
| 17924.0 | 13.150000 | 2 | 279.00 |
| 17951.0 | 11.333333 | 5 | 295.50 |
| 17968.0 | 11.616667 | 85 | 277.35 |
| 18074.0 | 14.116667 | 13 | 489.60 |
| 18085.0 | 11.866667 | 9 | 303.90 |
| Recency | Frequency | Monetary | R | F | M | |
|---|---|---|---|---|---|---|
| CustomerID | ||||||
| 12431.0 | 13.950000 | 14 | 358.25 | 2 | 2 | 3 |
| 12583.0 | 15.250000 | 20 | 855.86 | 1 | 3 | 4 |
| 12791.0 | 12.550000 | 2 | 192.60 | 3 | 1 | 1 |
| 12838.0 | 12.050000 | 59 | 390.79 | 3 | 4 | 3 |
| 13047.0 | 15.416667 | 17 | 366.63 | 1 | 3 | 3 |
| Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | |
|---|---|---|---|---|---|---|---|
| CustomerID | |||||||
| 12431.0 | 13.950000 | 14 | 358.25 | 2 | 2 | 3 | 2.02.03.0 |
| 12583.0 | 15.250000 | 20 | 855.86 | 1 | 3 | 4 | 1.03.04.0 |
| 12791.0 | 12.550000 | 2 | 192.60 | 3 | 1 | 1 | 3.01.01.0 |
| 12838.0 | 12.050000 | 59 | 390.79 | 3 | 4 | 3 | 3.04.03.0 |
| 13047.0 | 15.416667 | 17 | 366.63 | 1 | 3 | 3 | 1.03.03.0 |
34 CustomerID 12431.0 7 12583.0 8 12791.0 5 12838.0 10 13047.0 7 Name: RFM_Score, dtype: int64
| Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | RFM_Score | RFM_Level | |
|---|---|---|---|---|---|---|---|---|---|
| CustomerID | |||||||||
| 12431.0 | 13.950000 | 14 | 358.25 | 2 | 2 | 3 | 2.02.03.0 | 7 | Loyal/Commited |
| 12583.0 | 15.250000 | 20 | 855.86 | 1 | 3 | 4 | 1.03.04.0 | 8 | Champions |
| 12791.0 | 12.550000 | 2 | 192.60 | 3 | 1 | 1 | 3.01.01.0 | 5 | Promising |
| 12838.0 | 12.050000 | 59 | 390.79 | 3 | 4 | 3 | 3.04.03.0 | 10 | Can't Loose Them |
| 13047.0 | 15.416667 | 17 | 366.63 | 1 | 3 | 3 | 1.03.03.0 | 7 | Loyal/Commited |
| 13255.0 | 12.033333 | 6 | 225.70 | 3 | 2 | 1 | 3.02.01.0 | 6 | Potential |
| 13408.0 | 13.350000 | 11 | 1024.68 | 2 | 2 | 4 | 2.02.04.0 | 8 | Champions |
| 13448.0 | 13.116667 | 18 | 443.96 | 2 | 3 | 3 | 2.03.03.0 | 8 | Champions |
| 13694.0 | 11.800000 | 6 | 842.12 | 4 | 2 | 4 | 4.02.04.0 | 10 | Can't Loose Them |
| 13705.0 | 13.516667 | 10 | 318.14 | 2 | 2 | 2 | 2.02.02.0 | 6 | Potential |
| 13747.0 | 13.383333 | 1 | 79.60 | 2 | 1 | 1 | 2.01.01.0 | 4 | Requires Attention |
| 13748.0 | 15.000000 | 1 | 204.00 | 1 | 1 | 1 | 1.01.01.0 | 3 | Demands Activation |
| 13758.0 | 11.866667 | 17 | 362.45 | 4 | 3 | 3 | 4.03.03.0 | 10 | Can't Loose Them |
| 13767.0 | 13.216667 | 14 | 507.88 | 2 | 2 | 4 | 2.02.04.0 | 8 | Champions |
| 14045.0 | 12.466667 | 1 | 326.40 | 3 | 1 | 2 | 3.01.02.0 | 6 | Potential |
Recency Frequency Monetary
mean mean mean count
RFM_Level
Can't Loose Them 12.1 44.2 702.6 16
Champions 13.3 16.4 938.5 8
Demands Activation 14.5 1.0 70.4 3
Loyal/Commited 13.4 12.1 363.6 7
Potential 12.7 7.1 254.0 7
Promising 13.1 3.7 110.0 3
Requires Attention 14.2 2.8 222.4 4